🕷️️ Job Radar • SCRAPING

upwork.com 🟢 2026-05-26

🔹 Amazon Analytics Pipeline: SellerLabs to BigQuery
👤 Client: 🇺🇸 United States Member since 2024-03-12
💰 Price: ****
🚩 Problem: Fragile Looker dashboards querying SellerLabs directly, causing instability and lack of centralized data transformation.
📦 Existing: SellerLabs account, Google Sheets (catalogue, COGS, supply chain), Looker Studio dashboards.

Specifications:

[Target] Google BigQuery
[Method] Nightly automated extraction via API/SQL
[Stack] dbt (transformation layer), Python (scripting), MCP (Claude AI integration)
[Format] Looker Studio Dashboards (Sales, Profitability, PPC, Inventory)
[Target] Google Sheets API
[Security] Failure alerting system

Workflow:

1. Extraction of SellerLabs and Google Sheets data into BigQuery raw layer.
2. SQL transformation via dbt into business-ready tables (Sales, Profitability, PPC, Inventory).
3. Deployment of four Looker Studio dashboards on transformed BigQuery tables.
4. Integration of Claude AI to BigQuery via Model Context Protocol (MCP).